This article tells you how to download and delete the mysql binary log (log-bin) in MySQL command mode. If you need it, refer to it.
This article tells you how to download and delete the mysql binary log (log-bin) in MySQL command mode. If you need
The source of this article: http://www.cnblogs.com/wy123/p/6956464.htmlThis article only simulates using mysqldump and Log-bin binary logs for simple testing, only as a personal learning note, there may be a large gap from the actual application,
1. Turn on Bin-log(1) Inside the My.con configuration file[Mysqld] #选项添加Log-bin=mysql-bin #日志文件名称, location not specified, default data file locationRestart MySQL ServiceLog_bin is the file name of the generated bin-log, the suffix is the 6-digit
Find out what binary log files are currently
The code is as follows
Copy Code
Mysql> show binary logs;+------------------+-----------+| Log_name | File_size |+------------------+-----------+| mysql-bin.000001 | 1357315
Like most relational databases, log files are an important part of the MySQL database. MySQL has several different log files, usually including error log files, binary logs, generic logs, slow query logs, and so on. These logs can help us locate
Use the Python built-in functions: Bin (), Oct (), int (), Hex () to enable a binary conversion.
Let's look at the description of these built-in functions in the official Python document:
bin (x)
Convert an integer number to a binary string. The
Gray code, a code invented by French engineer Jean-maurice-emlle Baudot in 1880, is an absolute encoding, and the typical gray code is a one-step complement with reflective and cyclic characteristics, its cyclic, The single-step feature eliminates
The source of this article: http://www.cnblogs.com/wy123/p/7182356.html(It is not the original works right to retain the source, I my book still far to reach, just to link to the original text, because the following may exist some errors to amend or
MySQL binary log (binary log) Summary, mysqlbinary
Source: http://www.cnblogs.com/wy123/p/7182356.html(The Source retained is not the right of original works. My work is far from reaching this level, just to link to the original article, because
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.